Tabela ContractService

Definicja tabeli ContractService

Name

ContractService

Code

ContractService

Comment

 


Lista kolumn tabeli ContractService

Name

Code

ContractServID

ContractServID

ContractServiceKindID

ContractServiceKindID

ContractServiceTypeID

ContractServiceTypeID

ContractServiceUnitTypeID

ContractServiceUnitTypeID

ContractServiceRestrictionID

ContractServiceRestrictionID

Con_ContractServID

Con_ContractServID

Code

Code

ContractorCode

ContractorCode

ShortName

ShortName

FullName

FullName

PositionInContract

PositionInContract

MZContractCode

MZContractCode

Description

Description

Comments

Comments

Active

Active

Distinction

Distinction

ClassProductsAndServicesCode

ClassProductsAndServicesCode

ProductModel

ProductModel

ProductName

ProductName

ContractLimitType

ContractLimitType

VerificationDocument

VerificationDocument

AccountingLevel

AccountingLevel

FKIndex

FKIndex

InstitutionOrgUnitId

InstitutionOrgUnitId


Kolumna ContractServID tabeli ContractService

Definicja kolumny ContractServID tabeli ContractService

Name

ContractServID

Code

ContractServID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractServiceKindID tabeli ContractService

Definicja kolumny ContractServiceKindID tabeli ContractService

Name

ContractServiceKindID

Code

ContractServiceKindID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServiceTypeID tabeli ContractService

Definicja kolumny ContractServiceTypeID tabeli ContractService

Name

ContractServiceTypeID

Code

ContractServiceTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServiceUnitTypeID tabeli ContractService

Definicja kolumny ContractServiceUnitTypeID tabeli ContractService

Name

ContractServiceUnitTypeID

Code

ContractServiceUnitTypeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ContractServiceRestrictionID tabeli ContractService

Definicja kolumny ContractServiceRestrictionID tabeli ContractService

Name

ContractServiceRestrictionID

Code

ContractServiceRestrictionID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Con_ContractServID tabeli ContractService

Definicja kolumny Con_ContractServID tabeli ContractService

Name

Con_ContractServID

Code

Con_ContractServID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna Code tabeli ContractService

Definicja kolumny Code tabeli ContractService

Name

Code

Code

Code

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna ContractorCode tabeli ContractService

Definicja kolumny ContractorCode tabeli ContractService

Name

ContractorCode

Code

ContractorCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

 


Kolumna ShortName tabeli ContractService

Definicja kolumny ShortName tabeli ContractService

Name

ShortName

Code

ShortName

Data Type

VARCHAR2(50)

Mandatory

No

Comment

 


Kolumna FullName tabeli ContractService

Definicja kolumny FullName tabeli ContractService

Name

FullName

Code

FullName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

 


Kolumna PositionInContract tabeli ContractService

Definicja kolumny PositionInContract tabeli ContractService

Name

PositionInContract

Code

PositionInContract

Data Type

VARCHAR2(20)

Mandatory

No

Comment

 


Kolumna MZContractCode tabeli ContractService

Definicja kolumny MZContractCode tabeli ContractService

Name

MZContractCode

Code

MZContractCode

Data Type

VARCHAR2(12)

Mandatory

No

Comment

 


Kolumna Description tabeli ContractService

Definicja kolumny Description tabeli ContractService

Name

Description

Code

Description

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Comments tabeli ContractService

Definicja kolumny Comments tabeli ContractService

Name

Comments

Code

Comments

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Active tabeli ContractService

Definicja kolumny Active tabeli ContractService

Name

Active

Code

Active

Data Type

VARCHAR2(4)

Mandatory

No

Comment

 


Kolumna Distinction tabeli ContractService

Definicja kolumny Distinction tabeli ContractService

Name

Distinction

Code

Distinction

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ClassProductsAndServicesCode tabeli ContractService

Definicja kolumny ClassProductsAndServicesCode tabeli ContractService

Name

ClassProductsAndServicesCode

Code

ClassProductsAndServicesCode

Data Type

VARCHAR2(14)

Mandatory

No

Comment

 


Kolumna ProductModel tabeli ContractService

Definicja kolumny ProductModel tabeli ContractService

Name

ProductModel

Code

ProductModel

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna ProductName tabeli ContractService

Definicja kolumny ProductName tabeli ContractService

Name

ProductName

Code

ProductName

Data Type

VARCHAR2(200)

Mandatory

No

Comment

 


Kolumna ContractLimitType tabeli ContractService

Definicja kolumny ContractLimitType tabeli ContractService

Name

ContractLimitType

Code

ContractLimitType

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna VerificationDocument tabeli ContractService

Definicja kolumny VerificationDocument tabeli ContractService

Name

VerificationDocument

Code

VerificationDocument

Data Type

VARCHAR2(1)

Mandatory

No

Comment

 


Kolumna AccountingLevel tabeli ContractService

Definicja kolumny AccountingLevel tabeli ContractService

Name

AccountingLevel

Code

AccountingLevel

Data Type

VARCHAR2(2)

Mandatory

No

Comment

 


Kolumna FKIndex tabeli ContractService

Definicja kolumny FKIndex tabeli ContractService

Name

FKIndex

Code

FKIndex

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Kolumna ta bedzie przechowywala index który jest powiazany z zewnetrznymi systemami FK jak np SIMPLE.ARP. Jest to indeks który jest przypisany do produktów kontraktowych (pozycji na fakturze) w systemach FK. Ten identyfikator jest nadawany przez systemy FK i jest odpowiednikiem
naszego ConstractServID. Pole bedzie wykorzystywane do generowania faktur dla zewnetrznych systemów FK gdzie wymagane sa indeksy zalozone przez system FK


Kolumna InstitutionOrgUnitId tabeli ContractService

Definicja kolumny InstitutionOrgUnitId tabeli ContractService

Name

InstitutionOrgUnitId

Code

InstitutionOrgUnitId

Data Type

NUMBER(10)

Mandatory

No

Comment

link do "zakladu"


Lista kluczy tabeli ContractService

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli ContractService

Definicja klucza Identifier_1 tabeli ContractService

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment